TrustRadius Insights
Seamless Querying Process: Many reviewers have praised the ease of connecting to Snowflake and other servers, indicating that they have …
Starting at $11 per month per user
View PricingOverview
What is DBeaver?
DBeaver offers comprehensive data management tools designed to help teams explore, process, and administrate SQL, NoSQL, and cloud data sources. DBeaver is available commercially as DBeaver PRO and for free as DBeaver Community.
Recent Reviews
Popular Features
- Database change management (5)9.191%
- Schema maintenance (9)8.888%
- Database status reporting (6)8.484%
- User management (5)7.979%
Pricing
Lite Edition Subscription
$11
On Premise
per month per user
Enterprise Edition Subscription
$25
On Premise
per month per user
Lite Edition License
$110
On Premise
per year per user
Entry-level set up fee?
- No setup fee
For the latest information on pricing, visithttps://dbeaver.com/buy
Offerings
- Free Trial
- Free/Freemium Version
- Premium Consulting/Integration Services
Starting price (does not include set up fee)
- $11 per month per user
Features
Return to navigation
Product Details
- About
- Competitors
- Tech Details
- FAQs
What is DBeaver?
DBeaver is a universal database management tool, able to support SQL (MySQL, MariaDB, PostgreSQL, Microsoft SQL Server, Oracle, and IBM DB2, Sybase, etc.) and NoSQL databases (MongoDB, Couchbase, Redis, Cassandra, etc.), as well as cloud databases (AWS Redshift, Google BigQuery, Snowflake, etc.).
Connection to various data sources
- Choice of database driver from the variety of supported types. The list of drivers includes drivers for relational, document-oriented, key-value, time-series, and other databases.
- Support of user-defined connection types and creation of custom drivers an the Driver Manager
- Configuration of standard (host, port, user credentials) as well as advanced connection properties:
- SSH tunnel
- SOCKS proxy
- Shell commands to be executed before/after actual database connection
- Bootstrap SQL queries executing in the database session immediately after connecting
Data viewer and editor
- Multiple data views to fit the variety of users’ needs, for example display of image contents (gif, png, jpeg, bmp) as an images
- Editing of data inline and in a dedicated space
- Navigation among data
- Custom filters for table contents or query results, including filters based on cell values
- Results ordering by column
- Data export with all applied filters and orderings
- Generation of SQL statements based on selected rows
- Basic statistics for selected columns
Mock-Data Generator
The user can generate random data (or “mock" data) for tables. And this data should look like the real data. Enterprise edition includes basic and advanced data generators. Including (but not limited to):
- Numbers
- Random strings
- Names
- Addresses
- Credit cards
- Domains and IP addresses
- Custom regular expressions
- Flexible numeric generators
SQL editor
- Organization of scripts into folders and reassignment of database connections for particular scripts
- SQL syntax highlighting determined by the database associated with a script
- Support for different sets of reserved keywords and system functions for different databases
- Import and export of scripts
Visual Query Builder
- Construct complex SQL queries without actual knowledge of SQL
- Make table joins/filtering/ordering visually
- Open existing SQL queries in visual mode, edit and save them
- Execute a visually constructed query at any moment and get results on the screen
- Analyze complex SQL queries visually
Metadata browser
- A tree of database connections with their metadata structures down to the lowest level: tables, views, columns, indexes, procedures, triggers, storage entities (tablespaces, partitions), and security entities (users, roles)
- Ability to modify most metadata entities, depending on the database driver capabilities
- Display of database objects` DDL and generation of standard SQL92 DDL according to object structure for some databases
- Ability to edit/rename/delete connections and most database objects
- Global and local filters, ability to filter database objects by name
Data transfer
- Export of data to a file or to another database table with the option to create the destination table if it does not exist
- Supported file formats: CSV, HTML, XML, JSON, XLS, XLSX
- Import data directly from CSV file into database table. Setup columns mapping and data types in convenient wizards
- Save data transfer configurations as tasks and run them in one click
- Schedule data transfer tasks for later/recurrent execution
ER diagrams
- Automatically generated ER diagrams for a database/schema (with all tables) or for a single table (with all referenced/referencing tables)
- Customization of columns visibility
- Export of diagrams to the formats: GIF, PNG, BMP, GraphML
Data and metadata search
- Full-text data search against all chosen tables/views with search results shown as filtered tables/views
- Metadata search among rows in database system tables
- Ability to set an exact object name or a search mask
Database structure compare
- Ability to compare several database objects of any type: tables, schemas, entire databases, etc.
- Comparison results can be presented as: HTML, DDL alter scripts, Diff diagram, Liquibase changesets
- Database structure synchronization can be performed
While DBeaver offers a community edition at no cost, users of the Enterprise Edition have an access to the special online support system. They can write a ticket with question, bug or improvement and track it from the profile. The vendor states it usually takes no more than one working day to answer questions, and just a few days to fix bugs reported by the users.
DBeaver Features
Database Development Features
- Supported: Version control tools
- Supported: Test data generation
- Supported: Database change management
Database Administration Features
- Supported: User management
- Supported: Database security
- Supported: Database status reporting
- Supported: Change management
DBeaver Video
This demo video describes the main features of DBeaver
--
0:05 Connections
01:07 Cloud Explorer
02:08 Data Editor
04:04 Grid Colorization
05:36 Data Highlighting
07:04 Data Visualization
08:09 Spatial data
09:05 Value Panel
11:53 Calc & Group Panels
13:06 SQL Editor
16:4...
 Show More DBeaver Competitors
DBeaver Technical Details
| Deployment Types | On-premise |
|---|---|
| Operating Systems | Windows, Linux, Mac |
| Mobile Application | No |
Frequently Asked Questions
DBeaver offers comprehensive data management tools designed to help teams explore, process, and administrate SQL, NoSQL, and cloud data sources. DBeaver is available commercially as DBeaver PRO and for free as DBeaver Community.
DBeaver starts at $11.
Reviewers rate Database change management and Change management highest, with a score of 9.1.
The most common users of DBeaver are from Enterprises (1,001+ employees).
Comparisons
Compare with
Reviews and Ratings
(55)Attribute Ratings
Reviews
(1-4 of 4)Companies can't remove reviews or game the system. Here's why
February 09, 2023
Awesome connectivity, configurability, organization
DBeaver is used to connect, query, update and manage a variety of databases through many configurations. I personally use it because it can store many queries and associate them with a particular database or on a particular sheet with related queries. It can make diagnosing problems much more quickly than without organizational features.
- Complex connection configurations
- Managing and organizing queries for a large number of different databases
- Ability to make proposed updates and then write those once we are ready
- Better navigation especially on the main query screen
- Make icons fewer, simpler and more intuitive
- vim integration
86.66666666666666%
8.7
100%
10.0
- Positive Ability to manage DBeaver and query ad-hoc quickly
- By having the queries saved it has saved developer time and thereby increased the ROI on the investment on the tool
- This has made firefighting quicker and freed up resources for more development work.
Sequel Pro and Ace are much simpler but they have dangerous defaults such as writing updates without confirmation.
DBeaver is used by both software developers and people who are responsible of support services for a web application with large user base. It allows developers to quickly view and modify database as they are developing the application and testing features. For support people it helps to solve customer queries which need to get information from the database. They also use it to modify database when configuration options for the application needs to be changed.
- Easy to make and restore backups.
- Good UI for viewing table data & schema. No more command line ever again!
- Overall has a large feature set for all database related tasks (users, events etc...)
- The UI is not very modern and looks dated.
- A barely noticeable delay when changing views.
20%
2.0
60%
6.0
- Speeds up tasks that require viewing or changing data.
- Less need to manually write queries, less mistakes.
- Access different databases from one application (supports multiple vendors, save database credentials).
November 26, 2019
Great open-source SQL client
A lot of developers use DBeaver for its ease of use. It lets me as a developer do a lot more than a typical SQL client. I especially like the visualization that this tool offers to me. I can easily see how all the tables are connected in an ER diagram and I can make changes and modify it.
- Visuals.
- Autocomplete your SQL.
- Sometimes it's clunky and slow.
- One time it made changes to prod without me asking it to do anything.
76%
7.6
12.5%
1.3
- Free tool, so it's helped us save a lot of money.
DBeaver is more user-friendly than the other tools I have used. But security-wise, I don't trust it as much as other tools.
January 23, 2019
Great DB development tool!
Our development staff uses DBeaver for editing database/table schema (when needed) and for creating production deployment scripts. We are using the free community edition and it is extremely stable and works very well. Since it supports multiple databases, we can also use it for Microsoft's SQL Server, but we currently only use it for PostgreSQL. Compared to other products on the market, it did what we needed to do, even though sometimes the UI can be a little unintuitive compared to what we are used to with SQL Management Studio.
The basics are covered when viewing/editing data where it has the basic sorting and filtering in right-click menus. However, it's not as good of a product as dbForge Studio for PostgreSQL, where it's more intuitive to use.
While you can edit table/database schema, it's also not as intuitive. But for us, we don't use those features as much since we do code first database design. However, the real usefulness for us comes when generating DDL scripts. That's as simple as a right-click, generate SQL, and selecting DDL. Everything just works! We even use that to verify that our database looks proper after an update from our code first migrations in entity framework.
The basics are covered when viewing/editing data where it has the basic sorting and filtering in right-click menus. However, it's not as good of a product as dbForge Studio for PostgreSQL, where it's more intuitive to use.
While you can edit table/database schema, it's also not as intuitive. But for us, we don't use those features as much since we do code first database design. However, the real usefulness for us comes when generating DDL scripts. That's as simple as a right-click, generate SQL, and selecting DDL. Everything just works! We even use that to verify that our database looks proper after an update from our code first migrations in entity framework.
- Data import/export and SQL Script generation are quick and simple to do.
- Fairly intuitive when viewing/editing table data.
- Ability to save SQL scripts per server and recall them easily.
- Handy intelligence when writing queries, functions, and stored procs.
- Schema editing is not very intuitive. Editing a single column forces you into multiple tab windows when trying to change something simple like a column name.
- Sorting and filtering in data is nice, but buried in long right-click menus.
- Some things are definitely non-standard UI for a Windows application, so it might be hard for die-hard Windows fans to get used to.
90%
9.0
85%
8.5
- Saved our development team hours of work handcrafting database deployment scripts by generating DDL scripts for us.
dbForge Studio has a more intuitive UI for die-hard Windows users. It's also easier to use sorting and filtering in their grids. However, that one lacked the script generation and schema editing tools our development team needed to use on an almost daily basis.
Valentina had the features they needed, but the UI was just not palatable for them to use.
Valentina had the features they needed, but the UI was just not palatable for them to use.